SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'Čelade Airoh'
ORDER BY cena LIMIT 27,9
Airoh Wraap RAZE BLACK MATT
175,99 €
Airoh Wraap RAZE RED GLOSS
175,99 €
Airoh Wraap LOLLIPOP GLOSS
175,99 €
Airoh Wraap ALIEN RED MATT
175,99 €
Airoh Wraap ALIEN YELLOW MATT
175,99 €
Airoh ST301 Tide
199,99 € 179,99 €
Airoh ST301 Logo
199,99 € 179,99 €
Airoh Twist Crazy
179,99 €
Airoh Spark Rock'N'Roll
199,99 €